Mega Code Archive
System Tables Views
1) Check a view against sys views
2) Check the existance of a table by querying sysobjects
3) Constraint Names and System Catalog Entries
4) DELETE syslogins
5) Displays the trigger SQL definition (if the trigger is not encrypted)
6) Dropping all the triggers in the database using a cursor and dynamic execution
7) Find the names and types of objects that have encrypted text
8) Getting Details about User-Defined Functions in master
9) Join objects and schemas
10) Join objects and schemas for querying a user-defined function
11) Join sys columns and sys types
12) Join syscomments and sysobjects
13) Join sysdepends and syscolumns
14) List all the defined messages in sysmessages
15) Query name, principal_id, type_desc, default_schema_name, is_fixed_role from sys database_principals
16) Query sys databases
17) Query sys databases for database name
18) Query sys indexes
19) Query sys objects for object name
20) Query sys server_principals
21) Query sys syscacheobjects
22) Query sys syslogins
23) Query sys views
24) Query syscolumns
25) Query sysobjects for user table, not system table
26) Reporting on Database Views by joining sys columns and sys views
27) Reporting on Database Views by joining sys sql_dependencies, sys views and sys schemas
28) Reporting on Database Views by joining sys views and sys schemas
29) Reporting Stored Procedure Metadata
30) Resolving base datatypes from User Defined Datatypes
31) Retrieve information about the components in the schema collection
32) Retrieve information about the namespaces in the schema collection
33) Retrieving all of the triggers for each table
34) Retrieving an Objects Definition from syscomments
35) Retrieving Full-Text Catalog and Index Metadata
36) Returns space usage information
37) Select from sysfiles
38) Select FROM sysindexes WHERE id = object_id(HasText)
39) SELECT name, is_auto_close_on FROM sys databases
40) Selecting a list of users and their groups
41) Selecting the length of a column from syscolumns
42) Sys columns contains a row for each column of an object that has columns, such as tables and views
43) Sys database_principals INNER JOIN sys objects
44) Sys fn_varbintohexstr function
45) Sys objects catalog view contains a row for each object in the database
46) Sys objects INNER JOIN sys columns
47) Sysdatabases contains a row for every system and user-defined database on the SQL Server system
48) Sysdepends contains a row for every dependency relationship between tables, views, and stored procedures It appears in
49) Sysobjects contains a row for each database object
50) SYSUSERS table
51) Table sysindexes contains a row for each index and a row for each table without a clustered index
52) The sys fulltext_index_columns system catalog view lists all ull-text indexed columns in the database
53) The sys fulltext_indexes system catalog view lists all full-text indexes in the database
54) The system table sysconstraints contains one row for every integrity constraint that is defined for a database object
55) Verifying the existence of the default database
56) Viewing DDL Trigger Metadata by joining sys server_sql_modules and sys server_triggers
57) Viewing DDL Trigger Metadata by joining sys server_triggers and sys server_trigger_events
58) Viewing DDL Trigger Metadata by joining sys triggers and sys sql_modules
59) Viewing DDL Trigger Metadata by querying sys triggers
60) Viewing DML Trigger Metadata
61) Viewing exception text